OpenEdge Development:<br />Basic Database Tools Reports option

The Database

Reports menu option allows you to generate reports about the schema in the database. Table 8–2 describes the submenu that appears when you choose this option.

Table 8–2: Reports menu
Report
Detailed Table	Displays details about one or all tables in this database, including field, sequence, and index information.
Quick Table	Displays a summary of all the tables in this database.
Quick Field	Displays field information for one or all tables defined in the working database.
Quick Index	Displays index information for one or all tables defined in the working database.
PRO/SQL View	Displays PRO/SQL view information for all the views defined in the working database.
Sequence	Displays sequences information for all the sequences defined in the working database.
Trigger	Displays trigger information for all the triggers defined in the working database.
User	Displays the current database users, user IDs, and whether each user has a password. You specify this information with the Data Dictionary.
Table Relations	Displays the relations for one or all tables defined in the working database.
Storage Areas	Displays the storage area information for all storage areas defined in the working database.
Verify Data Width	Displays information about data that exceeds either the Data Dictionary format or width field.
Auditing Reports	A submenu of auditing reports. See Table 8–3 for a list of auditing reports.

If you are connected to an audit-enabled database, you can access the Auditing Reports submenu. Table 8–3 describes each auditing report.

Table 8–3: Auditing reports
Report	Description
Track Audit Policy Changes	Details audit policy maintenance, commit, and dump/load events. Events with the following IDs are tracked by this report: 300, 301, 10010, 10303, and 10304.
Track Database Schema Changes	Details schema modification actions such as creating tables and modifying sequence definitions. Events with IDs between 5000 and 5041 are tracked by this report.
Track Audit Data Administration (Dump/Load)	Details the dump, load, and archival of audit data. Events with the following IDs are tracked by this report: 10300, 10301, and 10302.
Track Application Data Administration (Dump/Load)	Details the dump and load of application data. Events with the following IDs are tracked by this report: 10213 and 10214.
Track User Account Changes	Details create, update, and delete events, as well as the user who made the changes. Events with the following IDs are tracked by this report: 100, 101, and 102.
Track Security Permissions Changes	Details role maintenance and permissions maintenance auditing events. Events with IDs between 510 and 517 are tracked by this report.
Track SQL Permissions Changes	Details create, update, and delete events, as well as the user who made the change. Events with IDs of 210 through 212 and 400 through 422 are tracked by this report.
Track Authentication System Changes	Details authentication system maintenance events and authentication system domain maintenance events. Events with IDs between 500 and 507 are tracked by this report.
Client Session Authentication	Details application access through authentication domains. Note: Because client session authentication data will not be recorded for Beta 2, the Client Session Authentication report will not generate output.
Database Administration Report (Utilities)	Details activities performed by command-line database administration utilities. Events with IDs between 10100 and 10212 are tracked by this report.
Database Access Report (Login/Logout/etc)	Details login and logout events performed on an OpenEdge database. Events with IDs between 10500 and 10611 are tracked by this report.
Custom Audit Data Filter	Allows you to limit the amount of custom audit data on which the Data Dictionary tool reports.